package com.qding.park.manager.pojo.example;

import java.util.ArrayList;
import java.util.List;

/**
 * @ClassName: TbInviteExample
 * @Description: 邀请单统计条件
 * @author Comsys-Administrator
 * @date 2016年10月9日 下午3:49:31
 *
 */
public class TbInviteExample {
	
	protected String orderByClause;

	protected boolean distinct;

	protected List<Criteria> oredCriteria;

	public TbInviteExample() {
		oredCriteria = new ArrayList<Criteria>();
	}

	public String getOrderByClause() {
		return orderByClause;
	}
	
//	public void orderByPayTimeDesc(){
//		this.orderByClause = "qdpk_feetrade.Create_date desc";
//	}
//	
	public void orderByCreateTimeDesc(){
		this.orderByClause = "qdpk_invitecard.Create_date desc";
	}
	public void setOrderByClause(String orderByClause) {
		this.orderByClause = orderByClause;
	}

	public boolean isDistinct() {
		return distinct;
	}

	public void setDistinct(boolean distinct) {
		this.distinct = distinct;
	}

	public List<Criteria> getOredCriteria() {
		return oredCriteria;
	}

	public void setOredCriteria(List<Criteria> oredCriteria) {
		this.oredCriteria = oredCriteria;
	}

	public Criteria createCriteria() {
		Criteria criteria = createCriteriaInternal();
		if (oredCriteria.size() == 0) {
			oredCriteria.add(criteria);
		}
		return criteria;
	}

	protected Criteria createCriteriaInternal() {
		Criteria criteria = new Criteria();
		return criteria;
	}

	public static class Criteria extends GeneratedCriteria {

		protected Criteria() {
			super();
		}
	}

	protected abstract static class GeneratedCriteria {
		protected List<Criterion> criteria;

		protected GeneratedCriteria() {
			super();
			criteria = new ArrayList<Criterion>();
		}

		public boolean isValid() {
			return criteria.size() > 0;
		}

		public List<Criterion> getAllCriteria() {
			return criteria;
		}

		public List<Criterion> getCriteria() {
			return criteria;
		}

		protected void addCriterion(String condition) {
			if (condition == null) {
				throw new RuntimeException("Value for condition cannot be null");
			}
			criteria.add(new Criterion(condition));
		}

		protected void addCriterion(String condition, Object value, String property) {
			if (value == null) {
				throw new RuntimeException("Value for " + property + " cannot be null");
			}
			criteria.add(new Criterion(condition, value));
		}

		protected void addCriterion(String condition, Object value1, Object value2, String property) {
			if (value1 == null || value2 == null) {
				throw new RuntimeException("Between values for " + property + " cannot be null");
			}
			criteria.add(new Criterion(condition, value1, value2));
		}

		public Criteria andCarnumEqualTo(String value) {
			addCriterion("qdpk_invitecard.carNum =", value, "carNum");
			return (Criteria) this;
		}
		
		public Criteria andCarnumLike(String value) {
			String v="CONCAT('%',"+"'"+value+"'"+",'%' )";
			addCriterion("qdpk_invitecard.carNum like "+v);
			return (Criteria) this;
		}
//		
//		public Criteria andPayChannelEqualTo(Object value) {
//			addCriterion("qdpk_feetrade.Channel =", value, "pay_channel");
//			return (Criteria) this;
//		}
//		
		public Criteria andParkIdEqualTo(Object value) {
			addCriterion("qdpk_invitecard.ParkID =", value, "parkID");
			return (Criteria) this;
		}
		
		public Criteria andParkIdIn(List<Integer> value) {
			addCriterion("qdpk_invitecard.ParkID in ", value, "parkID");
			return (Criteria) this;
		}
//		
//		 public Criteria andTradeIDIsNotNull() {
//	            addCriterion("qdpk_parkreserve.TradeID is not null");
//	            return (Criteria) this;
//	        }
//		 
//		 public Criteria andReserverTypeIsTemp() {
//	            addCriterion("qdpk_parkreserve.ReserverType !=1");
//	            return (Criteria) this;
//	        }
//		 
//		 public Criteria andReserverTypeIsRes() {
//	            addCriterion("qdpk_parkreserve.ReserverType =1");
//	            return (Criteria) this;
//	        }
//		public Criteria andPaytimeGreaterThanOrEqualTo(Object value) {
//			addCriterion("qdpk_feetrade.Create_date >=", value, "payTime");
//			return (Criteria) this;
//		}
//		
		public Criteria andCreateTimeGreaterThanOrEqualTo(Object value) {
			addCriterion("qdpk_invitecard.Create_date >=", value, "Create_date");
			return (Criteria) this;
		}
//
//		public Criteria andPaytimeLessThanOrEqualTo(Object value) {
//			addCriterion("qdpk_feetrade.Create_date <", value, "payTime");
//			return (Criteria) this;
//		}
//		
		public Criteria andCreateTimeLessThanOrEqualTo(Object value) {
			addCriterion("qdpk_invitecard.Create_date <", value, "Create_date");
			return (Criteria) this;
		}

	}

	public static class Criterion {
		private String condition;

		private Object value;

		private Object secondValue;

		private boolean noValue;

		private boolean singleValue;

		private boolean betweenValue;

		private boolean listValue;

		private String typeHandler;

		public String getCondition() {
			return condition;
		}

		public Object getValue() {
			return value;
		}

		public Object getSecondValue() {
			return secondValue;
		}

		public boolean isNoValue() {
			return noValue;
		}

		public boolean isSingleValue() {
			return singleValue;
		}

		public boolean isBetweenValue() {
			return betweenValue;
		}

		public boolean isListValue() {
			return listValue;
		}

		public String getTypeHandler() {
			return typeHandler;
		}

		protected Criterion(String condition) {
			super();
			this.condition = condition;
			this.typeHandler = null;
			this.noValue = true;
		}

		protected Criterion(String condition, Object value, String typeHandler) {
			super();
			this.condition = condition;
			this.value = value;
			this.typeHandler = typeHandler;
			if (value instanceof List<?>) {
				this.listValue = true;
			} else {
				this.singleValue = true;
			}
		}

		protected Criterion(String condition, Object value) {
			this(condition, value, null);
		}

		protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
			super();
			this.condition = condition;
			this.value = value;
			this.secondValue = secondValue;
			this.typeHandler = typeHandler;
			this.betweenValue = true;
		}

		protected Criterion(String condition, Object value, Object secondValue) {
			this(condition, value, secondValue, null);
		}
	}
}
